BEGIN TRANSACTION AddDriverSchedule1
	BEGIN TRY
		INSERT INTO [DriverSchedule] (DriverNo, StartDateTime, EndDateTime, WeekNo, VihicleRegNo, CurrentlyAvailable)
		VALUES (1, '01/07/18 08:00', '01/07/18 17:00', 71, 'CH99 1PP', 1)
		
		COMMIT TRANSACTION AddDriverSchedule1
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddDriverSchedule1
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddDriverSchedule2
	BEGIN TRY
		INSERT INTO [DriverSchedule] (DriverNo, StartDateTime, EndDateTime, WeekNo, VihicleRegNo, CurrentlyAvailable)
		VALUES (2, '01/06/18 08:00', '01/06/18 17:00', 31, 'CH19 1PP', 1)
		
		COMMIT TRANSACTION AddDriverSchedule2
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddDriverSchedule2
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddDriverSchedule3
	BEGIN TRY
		INSERT INTO [DriverSchedule] (DriverNo, StartDateTime, EndDateTime, WeekNo, VihicleRegNo, CurrentlyAvailable)
		VALUES (3, '01/08/18 08:00', '01/08/18 17:00', 52, 'CH11 1PP', 1)
		
		COMMIT TRANSACTION AddDriverSchedule3
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddDriverSchedule3
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddDriverSchedule4
	BEGIN TRY
		INSERT INTO [DriverSchedule] (DriverNo, StartDateTime, EndDateTime, WeekNo, VihicleRegNo, CurrentlyAvailable)
		VALUES (4, '10/07/18 08:00', '10/07/18 17:00', 21, 'CH22 1PP', 0)
		
		COMMIT TRANSACTION AddDriverSchedule4
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddDriverSchedule4
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;